DROP VIEW view_current_principal_id;
GO

DROP PROCEDURE proc_current_principal_id;
GO

DROP VIEW current_user_id_v1;
GO

DROP PROCEDURE current_user_id_p1;
GO

DROP VIEW current_user_id_v2;
GO

DROP PROCEDURE current_user_id_p2;
GO

DROP VIEW view_NULL_principal_id;
GO

DROP PROCEDURE proc_NULL_principal_id;
GO

DROP VIEW view_db_owner_principal_id;
GO

DROP PROCEDURE proc_db_owner_principal_id;
GO

DROP VIEW view_db_owner_principal_id_v1;
GO

DROP LOGIN testuser;
GO

DROP USER testuser;
GO

DROP ROLE roletest;
GO